package com.hs.srm.admin.modules.ssess.dao;

import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.hs.srm.admin.modules.ssess.entity.SsessEntity;
import com.hs.srm.admin.modules.ssess.vo.SsessAndProPurchRequest;
import com.hs.srm.admin.modules.ssess.vo.SsessVO;
import com.hs.srm.admin.modules.vendor.vo.SimpleVendorInfoVO;


/**
 * @author yanfei
 *
 * @date 2019年3月25日
 */
public interface SsessDao extends BaseMapper<SsessEntity> {

	SsessEntity findByCodeAndfactory(@Param("vendorcode") String vendorcode,@Param("factory") String factory);
	
	SsessEntity findByVendorCode(@Param("vendorcode") String vendorcode);
	
	int findCount(@Param("vendorcode") String vendorcode,@Param("factory") String factory);
	
	SsessEntity findByCodeAndfactoryAnddate(@Param("vendorcode") String vendorcode,@Param("factory") String factory,
			@Param("begindate")  Date begindate,@Param("enddate") Date enddate);
	
	List<SsessVO> findBySsessAndQuota(@Param("begindate")  Date begindate,@Param("enddate") Date enddate);
	
	SsessEntity findBySesss(@Param("vendorcode") String vendorcode,@Param("factory") String factory,@Param("materialCode") String materialCode);
	
	
}
